[dbo].[asi_CancelPendingPublishRequestForContent]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_CancelPendingPublishRequestForContent

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ContentDocumentKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_CancelPendingPublishRequestForContent]
    @ContentDocumentKey uniqueidentifier
AS
BEGIN
    UPDATE PublishRequestDetail
       SET PublishRequestStatusCode = 2 --canceled
     WHERE ContentDocumentKey = @ContentDocumentKey
       AND (PublishRequestStatusCode = 0
        OR  (PublishRequestStatusCode = 1 AND Frequency > 0))
END

GO

Uses

[dbo].[PublishRequestDetail]
dbo